Pandas Profiling Report

Dataset statistics

Number of variables	18
Number of observations	4600
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.9 MiB
Average record size in memory	443.8 B

Variable types

DateTime	1
Numeric	10
Categorical	5
Text	2

Alerts

`country` has constant value "USA"	Constant
`bathrooms` is highly overall correlated with `bedrooms` and 4 other fields	High correlation
`bedrooms` is highly overall correlated with `bathrooms` and 2 other fields	High correlation
`floors` is highly overall correlated with `bathrooms` and 2 other fields	High correlation
`price` is highly overall correlated with `sqft_above` and 1 other fields	High correlation
`sqft_above` is highly overall correlated with `bathrooms` and 4 other fields	High correlation
`sqft_living` is highly overall correlated with `bathrooms` and 3 other fields	High correlation
`yr_built` is highly overall correlated with `bathrooms` and 1 other fields	High correlation
`waterfront` is highly imbalanced (93.9%)	Imbalance
`view` is highly imbalanced (71.9%)	Imbalance
`price` is highly skewed (γ1 = 24.79093256)	Skewed
`price` has 49 (1.1%) zeros	Zeros
`sqft_basement` has 2745 (59.7%) zeros	Zeros
`yr_renovated` has 2735 (59.5%) zeros	Zeros

Reproduction

Analysis started	2025-02-05 04:25:41.866946
Analysis finished	2025-02-05 04:25:53.767604
Duration	11.9 seconds
Software version	ydata-profiling vv4.12.2
Download configuration	config.json

date
Date

Distinct	70
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Memory size	36.1 KiB

Minimum	2014-05-02 00:00:00
Maximum	2014-07-10 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

price
Real number (ℝ)

High correlation Skewed Zeros

Distinct	1741
Distinct (%)	37.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	551962.99

Minimum	0
Maximum	26590000
Zeros	49
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	36.1 KiB

Quantile statistics

Minimum	0
5-th percentile	200000
Q1	322875
median	460943.46
Q3	654962.5
95-th percentile	1184050
Maximum	26590000
Range	26590000
Interquartile range (IQR)	332087.5

Descriptive statistics

Standard deviation	563834.7
Coefficient of variation (CV)	1.0215082
Kurtosis	1044.3522
Mean	551962.99
Median Absolute Deviation (MAD)	157500
Skewness	24.790933
Sum	2.5390297 × 10⁹
Variance	3.1790957 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	49	1.1%
300000	42	0.9%
400000	31	0.7%
600000	29	0.6%
450000	29	0.6%
440000	29	0.6%
350000	28	0.6%
250000	27	0.6%
550000	27	0.6%
415000	27	0.6%
Other values (1731)	4282	93.1%

Value	Count	Frequency (%)
0	49	1.1%
7800	1	< 0.1%
80000	1	< 0.1%
83000	1	< 0.1%
83300	2	< 0.1%
84350	1	< 0.1%
87500	1	< 0.1%
90000	2	< 0.1%
100000	4	0.1%
102500	1	< 0.1%

Value	Count	Frequency (%)
26590000	1	< 0.1%
12899000	1	< 0.1%
7062500	1	< 0.1%
4668000	1	< 0.1%
4489000	1	< 0.1%
3800000	1	< 0.1%
3710000	1	< 0.1%
3200000	1	< 0.1%
3100000	1	< 0.1%
3000000	1	< 0.1%

bedrooms
Real number (ℝ)

High correlation

Distinct	10
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.4008696

Minimum	0
Maximum	9
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	36.1 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	3
median	3
Q3	4
95-th percentile	5
Maximum	9
Range	9
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.90884812
Coefficient of variation (CV)	0.26723992
Kurtosis	1.2353774
Mean	3.4008696
Median Absolute Deviation (MAD)	1
Skewness	0.45644663
Sum	15644
Variance	0.8260049
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
3	2032	44.2%
4	1531	33.3%
2	566	12.3%
5	353	7.7%
6	61	1.3%
1	38	0.8%
7	14	0.3%
8	2	< 0.1%
0	2	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
0	2	< 0.1%
1	38	0.8%
2	566	12.3%
3	2032	44.2%
4	1531	33.3%
5	353	7.7%
6	61	1.3%
7	14	0.3%
8	2	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
9	1	< 0.1%
8	2	< 0.1%
7	14	0.3%
6	61	1.3%
5	353	7.7%
4	1531	33.3%
3	2032	44.2%
2	566	12.3%
1	38	0.8%
0	2	< 0.1%

bathrooms
Real number (ℝ)

High correlation

Distinct	26
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.1608152

Minimum	0
Maximum	8
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	36.1 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1.75
median	2.25
Q3	2.5
95-th percentile	3.5
Maximum	8
Range	8
Interquartile range (IQR)	0.75

Descriptive statistics

Standard deviation	0.78378107
Coefficient of variation (CV)	0.36272471
Kurtosis	1.8659047
Mean	2.1608152
Median Absolute Deviation (MAD)	0.5
Skewness	0.61603272
Sum	9939.75
Variance	0.61431277
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=26)

Value	Count	Frequency (%)
2.5	1189	25.8%
1	743	16.2%
1.75	629	13.7%
2	427	9.3%
2.25	419	9.1%
1.5	291	6.3%
2.75	276	6.0%
3	167	3.6%
3.5	162	3.5%
3.25	136	3.0%
Other values (16)	161	3.5%

Value	Count	Frequency (%)
0	2	< 0.1%
0.75	17	0.4%
1	743	16.2%
1.25	3	0.1%
1.5	291	6.3%
1.75	629	13.7%
2	427	9.3%
2.25	419	9.1%
2.5	1189	25.8%
2.75	276	6.0%

Value	Count	Frequency (%)
8	1	< 0.1%
6.75	1	< 0.1%
6.5	1	< 0.1%
6.25	2	< 0.1%
5.75	1	< 0.1%
5.5	4	0.1%
5.25	4	0.1%
5	6	0.1%
4.75	7	0.2%
4.5	29	0.6%

sqft_living
Real number (ℝ)

High correlation

Distinct	566
Distinct (%)	12.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2139.347

Minimum	370
Maximum	13540
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	36.1 KiB

Quantile statistics

Minimum	370
5-th percentile	950
Q1	1460
median	1980
Q3	2620
95-th percentile	3870
Maximum	13540
Range	13170
Interquartile range (IQR)	1160

Descriptive statistics

Standard deviation	963.20692
Coefficient of variation (CV)	0.45023408
Kurtosis	8.2916826
Mean	2139.347
Median Absolute Deviation (MAD)	570
Skewness	1.7235133
Sum	9840996
Variance	927767.56
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1940	32	0.7%
1720	32	0.7%
1840	31	0.7%
1660	31	0.7%
2000	30	0.7%
1410	29	0.6%
1200	28	0.6%
1480	28	0.6%
1890	27	0.6%
1490	27	0.6%
Other values (556)	4305	93.6%

Value	Count	Frequency (%)
370	1	< 0.1%
380	1	< 0.1%
420	1	< 0.1%
430	1	< 0.1%
490	1	< 0.1%
520	1	< 0.1%
550	1	< 0.1%
560	1	< 0.1%
580	1	< 0.1%
590	2	< 0.1%

Value	Count	Frequency (%)
13540	1	< 0.1%
10040	1	< 0.1%
9640	1	< 0.1%
8670	1	< 0.1%
8020	1	< 0.1%
7320	1	< 0.1%
7270	1	< 0.1%
7050	1	< 0.1%
6980	1	< 0.1%
6900	1	< 0.1%

sqft_lot
Real number (ℝ)

Distinct	3113
Distinct (%)	67.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14852.516

Minimum	638
Maximum	1074218
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	36.1 KiB

Quantile statistics

Minimum	638
5-th percentile	1690.8
Q1	5000.75
median	7683
Q3	11001.25
95-th percentile	43560
Maximum	1074218
Range	1073580
Interquartile range (IQR)	6000.5

Descriptive statistics

Standard deviation	35884.436
Coefficient of variation (CV)	2.416051
Kurtosis	219.87299
Mean	14852.516
Median Absolute Deviation (MAD)	2772
Skewness	11.307139
Sum	68321574
Variance	1.2876928 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5000	80	1.7%
6000	65	1.4%
4000	54	1.2%
7200	50	1.1%
4800	29	0.6%
9600	25	0.5%
4500	25	0.5%
7500	23	0.5%
5500	23	0.5%
3000	23	0.5%
Other values (3103)	4203	91.4%

Value	Count	Frequency (%)
638	1	< 0.1%
681	1	< 0.1%
704	1	< 0.1%
746	1	< 0.1%
747	1	< 0.1%
750	1	< 0.1%
779	1	< 0.1%
833	1	< 0.1%
835	1	< 0.1%
844	2	< 0.1%

Value	Count	Frequency (%)
1074218	1	< 0.1%
641203	1	< 0.1%
478288	1	< 0.1%
435600	2	< 0.1%
423838	1	< 0.1%
389126	1	< 0.1%
327135	1	< 0.1%
307752	1	< 0.1%
306848	1	< 0.1%
284011	1	< 0.1%

floors
Real number (ℝ)

High correlation

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.5120652

Minimum	1
Maximum	3.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	36.1 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1.5
Q3	2
95-th percentile	2
Maximum	3.5
Range	2.5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.53828838
Coefficient of variation (CV)	0.35599548
Kurtosis	-0.53885198
Mean	1.5120652
Median Absolute Deviation (MAD)	0.5
Skewness	0.55144065
Sum	6955.5
Variance	0.28975438
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	2174	47.3%
2	1811	39.4%
1.5	444	9.7%
3	128	2.8%
2.5	41	0.9%
3.5	2	< 0.1%

Value	Count	Frequency (%)
1	2174	47.3%
1.5	444	9.7%
2	1811	39.4%
2.5	41	0.9%
3	128	2.8%
3.5	2	< 0.1%

Value	Count	Frequency (%)
3.5	2	< 0.1%
3	128	2.8%
2.5	41	0.9%
2	1811	39.4%
1.5	444	9.7%
1	2174	47.3%

waterfront
Categorical

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	260.7 KiB

0	4567
1	33

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	4600
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	4567	99.3%
1	33	0.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	4567	99.3%
1	33	0.7%

Most occurring characters

Value	Count	Frequency (%)
0	4567	99.3%
1	33	0.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4600	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	4567	99.3%
1	33	0.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4600	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	4567	99.3%
1	33	0.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4600	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	4567	99.3%
1	33	0.7%

view
Categorical

Imbalance

Distinct	5
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	260.7 KiB

0	4140
2	205
3	116
4	70
1	69

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	4600
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	4
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	4140	90.0%
2	205	4.5%
3	116	2.5%
4	70	1.5%
1	69	1.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	4140	90.0%
2	205	4.5%
3	116	2.5%
4	70	1.5%
1	69	1.5%

Most occurring characters

Value	Count	Frequency (%)
0	4140	90.0%
2	205	4.5%
3	116	2.5%
4	70	1.5%
1	69	1.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4600	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	4140	90.0%
2	205	4.5%
3	116	2.5%
4	70	1.5%
1	69	1.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4600	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	4140	90.0%
2	205	4.5%
3	116	2.5%
4	70	1.5%
1	69	1.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4600	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	4140	90.0%
2	205	4.5%
3	116	2.5%
4	70	1.5%
1	69	1.5%

condition
Categorical

Distinct	5
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	260.7 KiB

3	2875
4	1252
5	435
2	32
1	6

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	4600
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3
2nd row	5
3rd row	4
4th row	4
5th row	4

Common Values

Value	Count	Frequency (%)
3	2875	62.5%
4	1252	27.2%
5	435	9.5%
2	32	0.7%
1	6	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
3	2875	62.5%
4	1252	27.2%
5	435	9.5%
2	32	0.7%
1	6	0.1%

Most occurring characters

Value	Count	Frequency (%)
3	2875	62.5%
4	1252	27.2%
5	435	9.5%
2	32	0.7%
1	6	0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4600	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
3	2875	62.5%
4	1252	27.2%
5	435	9.5%
2	32	0.7%
1	6	0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4600	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
3	2875	62.5%
4	1252	27.2%
5	435	9.5%
2	32	0.7%
1	6	0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4600	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
3	2875	62.5%
4	1252	27.2%
5	435	9.5%
2	32	0.7%
1	6	0.1%

sqft_above
Real number (ℝ)

High correlation

Distinct	511
Distinct (%)	11.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1827.2654

Minimum	370
Maximum	9410
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	36.1 KiB

Quantile statistics

Minimum	370
5-th percentile	860
Q1	1190
median	1590
Q3	2300
95-th percentile	3440
Maximum	9410
Range	9040
Interquartile range (IQR)	1110

Descriptive statistics

Standard deviation	862.16898
Coefficient of variation (CV)	0.47183565
Kurtosis	4.0701383
Mean	1827.2654
Median Absolute Deviation (MAD)	490
Skewness	1.4942107
Sum	8405421
Variance	743335.34
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1010	47	1.0%
1200	47	1.0%
1300	45	1.0%
1140	44	1.0%
1320	43	0.9%
1150	42	0.9%
1180	40	0.9%
1090	40	0.9%
1400	38	0.8%
1050	37	0.8%
Other values (501)	4177	90.8%

Value	Count	Frequency (%)
370	1	< 0.1%
380	1	< 0.1%
420	1	< 0.1%
430	1	< 0.1%
490	1	< 0.1%
520	1	< 0.1%
550	3	0.1%
560	1	< 0.1%
580	1	< 0.1%
590	2	< 0.1%

Value	Count	Frequency (%)
9410	1	< 0.1%
8020	1	< 0.1%
7680	1	< 0.1%
7320	1	< 0.1%
6640	1	< 0.1%
6430	1	< 0.1%
6420	1	< 0.1%
6120	1	< 0.1%
6070	1	< 0.1%
6050	1	< 0.1%

sqft_basement
Real number (ℝ)

Zeros

Distinct	207
Distinct (%)	4.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	312.08152

Minimum	0
Maximum	4820
Zeros	2745
Zeros (%)	59.7%
Negative	0
Negative (%)	0.0%
Memory size	36.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	610
95-th percentile	1210
Maximum	4820
Range	4820
Interquartile range (IQR)	610

Descriptive statistics

Standard deviation	464.13723
Coefficient of variation (CV)	1.4872307
Kurtosis	4.08238
Mean	312.08152
Median Absolute Deviation (MAD)	0
Skewness	1.6427322
Sum	1435575
Variance	215423.37
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2745	59.7%
500	53	1.2%
600	45	1.0%
800	43	0.9%
900	41	0.9%
700	38	0.8%
1000	33	0.7%
400	33	0.7%
550	27	0.6%
750	26	0.6%
Other values (197)	1516	33.0%

Value	Count	Frequency (%)
0	2745	59.7%
20	1	< 0.1%
50	1	< 0.1%
60	2	< 0.1%
65	1	< 0.1%
70	1	< 0.1%
80	3	0.1%
90	2	< 0.1%
100	14	0.3%
110	2	< 0.1%

Value	Count	Frequency (%)
4820	1	< 0.1%
4130	1	< 0.1%
2850	1	< 0.1%
2730	1	< 0.1%
2550	2	< 0.1%
2360	1	< 0.1%
2330	1	< 0.1%
2300	1	< 0.1%
2200	1	< 0.1%
2180	1	< 0.1%

yr_built
Real number (ℝ)

High correlation

Distinct	115
Distinct (%)	2.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1970.7863

Minimum	1900
Maximum	2014
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	36.1 KiB

Quantile statistics

Minimum	1900
5-th percentile	1913
Q1	1951
median	1976
Q3	1997
95-th percentile	2009
Maximum	2014
Range	114
Interquartile range (IQR)	46

Descriptive statistics

Standard deviation	29.731848
Coefficient of variation (CV)	0.015086287
Kurtosis	-0.6700759
Mean	1970.7863
Median Absolute Deviation (MAD)	23
Skewness	-0.50215519
Sum	9065617
Variance	883.98281
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2006	111	2.4%
2005	104	2.3%
2007	93	2.0%
2004	92	2.0%
1978	90	2.0%
2008	89	1.9%
2003	89	1.9%
1967	82	1.8%
1977	80	1.7%
2014	78	1.7%
Other values (105)	3692	80.3%

Value	Count	Frequency (%)
1900	22	0.5%
1901	9	0.2%
1902	10	0.2%
1903	10	0.2%
1904	9	0.2%
1905	19	0.4%
1906	27	0.6%
1907	12	0.3%
1908	19	0.4%
1909	22	0.5%

Value	Count	Frequency (%)
2014	78	1.7%
2013	57	1.2%
2012	33	0.7%
2011	24	0.5%
2010	28	0.6%
2009	50	1.1%
2008	89	1.9%
2007	93	2.0%
2006	111	2.4%
2005	104	2.3%

yr_renovated
Real number (ℝ)

Zeros

Distinct	60
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	808.60826

Minimum	0
Maximum	2014
Zeros	2735
Zeros (%)	59.5%
Negative	0
Negative (%)	0.0%
Memory size	36.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1999
95-th percentile	2011
Maximum	2014
Range	2014
Interquartile range (IQR)	1999

Descriptive statistics

Standard deviation	979.41454
Coefficient of variation (CV)	1.2112349
Kurtosis	-1.8511109
Mean	808.60826
Median Absolute Deviation (MAD)	0
Skewness	0.3859187
Sum	3719598
Variance	959252.83
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2735	59.5%
2000	170	3.7%
2003	151	3.3%
2009	109	2.4%
2001	109	2.4%
2005	95	2.1%
2004	77	1.7%
2014	72	1.6%
2006	68	1.5%
2013	61	1.3%
Other values (50)	953	20.7%

Value	Count	Frequency (%)
0	2735	59.5%
1912	33	0.7%
1913	1	< 0.1%
1923	57	1.2%
1934	6	0.1%
1945	7	0.2%
1948	1	< 0.1%
1953	1	< 0.1%
1954	8	0.2%
1955	2	< 0.1%

Value	Count	Frequency (%)
2014	72	1.6%
2013	61	1.3%
2012	45	1.0%
2011	54	1.2%
2010	30	0.7%
2009	109	2.4%
2008	45	1.0%
2007	7	0.2%
2006	68	1.5%
2005	95	2.1%

street
Text

Distinct	4525
Distinct (%)	98.4%
Missing	0
Missing (%)	0.0%
Memory size	332.6 KiB

Length

Max length	46
Median length	40
Mean length	17.018261
Min length	8

Characters and Unicode

Total characters	78284
Distinct characters	62
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4453 ?
Unique (%)	96.8%

Sample

1st row	18810 Densmore Ave N
2nd row	709 W Blaine St
3rd row	26206-26214 143rd Ave SE
4th row	857 170th Pl NE
5th row	9105 170th Ave NE

Value	Count	Frequency (%)
ave	1940	10.5%
ne	1358	7.4%
se	1180	6.4%
st	1171	6.3%
pl	807	4.4%
s	562	3.0%
sw	513	2.8%
n	292	1.6%
nw	288	1.6%
ct	173	0.9%
Other values (4805)	10157	55.1%

Most occurring characters

Value	Count	Frequency (%)
	13841	17.7%
1	5952	7.6%
t	4628	5.9%
2	4618	5.9%
S	3522	4.5%
0	3119	4.0%
3	3090	3.9%
e	2891	3.7%
h	2787	3.6%
4	2775	3.5%
Other values (52)	31061	39.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	78284	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	13841	17.7%
1	5952	7.6%
t	4628	5.9%
2	4618	5.9%
S	3522	4.5%
0	3119	4.0%
3	3090	3.9%
e	2891	3.7%
h	2787	3.6%
4	2775	3.5%
Other values (52)	31061	39.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	78284	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	13841	17.7%
1	5952	7.6%
t	4628	5.9%
2	4618	5.9%
S	3522	4.5%
0	3119	4.0%
3	3090	3.9%
e	2891	3.7%
h	2787	3.6%
4	2775	3.5%
Other values (52)	31061	39.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	78284	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	13841	17.7%
1	5952	7.6%
t	4628	5.9%
2	4618	5.9%
S	3522	4.5%
0	3119	4.0%
3	3090	3.9%
e	2891	3.7%
h	2787	3.6%
4	2775	3.5%
Other values (52)	31061	39.7%

city
Categorical

Distinct	44
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Memory size	291.0 KiB

Seattle	1573
Renton	293
Bellevue	286
Redmond	235
Kirkland	187
Other values (39)	2026

Length

Max length	19
Median length	18
Mean length	7.753913
Min length	4

Characters and Unicode

Total characters	35668
Distinct characters	45
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	0.1%

Sample

1st row	Shoreline
2nd row	Seattle
3rd row	Kent
4th row	Bellevue
5th row	Redmond

Common Values

Value	Count	Frequency (%)
Seattle	1573	34.2%
Renton	293	6.4%
Bellevue	286	6.2%
Redmond	235	5.1%
Kirkland	187	4.1%
Issaquah	187	4.1%
Kent	185	4.0%
Auburn	176	3.8%
Sammamish	175	3.8%
Federal Way	148	3.2%
Other values (34)	1155	25.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
seattle	1573	30.4%
renton	293	5.7%
bellevue	286	5.5%
redmond	235	4.5%
kirkland	187	3.6%
issaquah	187	3.6%
kent	185	3.6%
auburn	176	3.4%
sammamish	175	3.4%
federal	148	2.9%
Other values (47)	1722	33.3%

Most occurring characters

Value	Count	Frequency (%)
e	6423	18.0%
t	3861	10.8%
l	3602	10.1%
a	3573	10.0%
n	2261	6.3%
S	1975	5.5%
o	1382	3.9%
r	1137	3.2%
d	1113	3.1%
i	1079	3.0%
Other values (35)	9262	26.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	35668	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	6423	18.0%
t	3861	10.8%
l	3602	10.1%
a	3573	10.0%
n	2261	6.3%
S	1975	5.5%
o	1382	3.9%
r	1137	3.2%
d	1113	3.1%
i	1079	3.0%
Other values (35)	9262	26.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	35668	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	6423	18.0%
t	3861	10.8%
l	3602	10.1%
a	3573	10.0%
n	2261	6.3%
S	1975	5.5%
o	1382	3.9%
r	1137	3.2%
d	1113	3.1%
i	1079	3.0%
Other values (35)	9262	26.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	35668	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	6423	18.0%
t	3861	10.8%
l	3602	10.1%
a	3573	10.0%
n	2261	6.3%
S	1975	5.5%
o	1382	3.9%
r	1137	3.2%
d	1113	3.1%
i	1079	3.0%
Other values (35)	9262	26.0%

statezip
Text

Distinct	77
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Memory size	292.1 KiB

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	36800
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	WA 98133
2nd row	WA 98119
3rd row	WA 98042
4th row	WA 98008
5th row	WA 98052

Value	Count	Frequency (%)
wa	4600	50.0%
98103	148	1.6%
98052	135	1.5%
98117	132	1.4%
98115	130	1.4%
98006	110	1.2%
98059	106	1.2%
98042	100	1.1%
98034	99	1.1%
98053	98	1.1%
Other values (68)	3542	38.5%

Most occurring characters

Value	Count	Frequency (%)
8	5274	14.3%
9	5201	14.1%
W	4600	12.5%
	4600	12.5%
A	4600	12.5%
0	3695	10.0%
1	2741	7.4%
5	1275	3.5%
2	1244	3.4%
3	1146	3.1%
Other values (3)	2424	6.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	36800	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
8	5274	14.3%
9	5201	14.1%
W	4600	12.5%
	4600	12.5%
A	4600	12.5%
0	3695	10.0%
1	2741	7.4%
5	1275	3.5%
2	1244	3.4%
3	1146	3.1%
Other values (3)	2424	6.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	36800	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
8	5274	14.3%
9	5201	14.1%
W	4600	12.5%
	4600	12.5%
A	4600	12.5%
0	3695	10.0%
1	2741	7.4%
5	1275	3.5%
2	1244	3.4%
3	1146	3.1%
Other values (3)	2424	6.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	36800	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
8	5274	14.3%
9	5201	14.1%
W	4600	12.5%
	4600	12.5%
A	4600	12.5%
0	3695	10.0%
1	2741	7.4%
5	1275	3.5%
2	1244	3.4%
3	1146	3.1%
Other values (3)	2424	6.6%

country
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	269.7 KiB

USA	4600

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	13800
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	USA
2nd row	USA
3rd row	USA
4th row	USA
5th row	USA

Common Values

Value	Count	Frequency (%)
USA	4600	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
usa	4600	100.0%

Most occurring characters

Value	Count	Frequency (%)
U	4600	33.3%
S	4600	33.3%
A	4600	33.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	13800	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
U	4600	33.3%
S	4600	33.3%
A	4600	33.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	13800	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
U	4600	33.3%
S	4600	33.3%
A	4600	33.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	13800	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
U	4600	33.3%
S	4600	33.3%
A	4600	33.3%

	bathrooms	bedrooms	city	condition	floors	price	sqft_above	sqft_basement	sqft_living	sqft_lot	view	waterfront	yr_built	yr_renovated
bathrooms	1.000	0.538	0.145	0.129	0.540	0.492	0.696	0.190	0.747	0.092	0.146	0.166	0.530	-0.213
bedrooms	0.538	1.000	0.098	0.066	0.220	0.338	0.533	0.248	0.652	0.238	0.086	0.000	0.160	-0.056
city	0.145	0.098	1.000	0.131	0.190	0.114	0.180	0.113	0.148	0.185	0.113	0.234	0.267	0.213
condition	0.129	0.066	0.131	1.000	0.186	0.000	0.108	0.117	0.046	0.052	0.027	0.000	0.265	0.217
floors	0.540	0.220	0.190	0.186	1.000	0.321	0.604	-0.288	0.397	-0.204	0.033	0.000	0.538	-0.229
price	0.492	0.338	0.114	0.000	0.321	1.000	0.534	0.237	0.631	0.075	0.094	0.226	0.084	-0.071
sqft_above	0.696	0.533	0.180	0.108	0.604	0.534	1.000	-0.172	0.843	0.305	0.102	0.134	0.460	-0.169
sqft_basement	0.190	0.248	0.113	0.117	-0.288	0.237	-0.172	1.000	0.323	0.023	0.195	0.211	-0.212	0.054
sqft_living	0.747	0.652	0.148	0.046	0.397	0.631	0.843	0.323	1.000	0.325	0.173	0.269	0.322	-0.127
sqft_lot	0.092	0.238	0.185	0.052	-0.204	0.075	0.305	0.023	0.325	1.000	0.049	0.000	-0.012	0.051
view	0.146	0.086	0.113	0.027	0.033	0.094	0.102	0.195	0.173	0.049	1.000	0.483	0.055	0.050
waterfront	0.166	0.000	0.234	0.000	0.000	0.226	0.134	0.211	0.269	0.000	0.483	1.000	0.026	0.000
yr_built	0.530	0.160	0.267	0.265	0.538	0.084	0.460	-0.212	0.322	-0.012	0.055	0.026	1.000	-0.315
yr_renovated	-0.213	-0.056	0.213	0.217	-0.229	-0.071	-0.169	0.054	-0.127	0.051	0.050	0.000	-0.315	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	date	price	bedrooms	bathrooms	sqft_living	sqft_lot	floors	view	condition	sqft_above	sqft_basement	yr_built	yr_renovated	street	city	statezip	country
0	2014-05-02 00:00:00	313000.0	3.0	1.50	1340	7912	1.5	0	3	1340	0	1955	2005	18810 Densmore Ave N	Shoreline	WA 98133	USA
1	2014-05-02 00:00:00	2384000.0	5.0	2.50	3650	9050	2.0	4	5	3370	280	1921	0	709 W Blaine St	Seattle	WA 98119	USA
2	2014-05-02 00:00:00	342000.0	3.0	2.00	1930	11947	1.0	0	4	1930	0	1966	0	26206-26214 143rd Ave SE	Kent	WA 98042	USA
3	2014-05-02 00:00:00	420000.0	3.0	2.25	2000	8030	1.0	0	4	1000	1000	1963	0	857 170th Pl NE	Bellevue	WA 98008	USA
4	2014-05-02 00:00:00	550000.0	4.0	2.50	1940	10500	1.0	0	4	1140	800	1976	1992	9105 170th Ave NE	Redmond	WA 98052	USA
5	2014-05-02 00:00:00	490000.0	2.0	1.00	880	6380	1.0	0	3	880	0	1938	1994	522 NE 88th St	Seattle	WA 98115	USA
6	2014-05-02 00:00:00	335000.0	2.0	2.00	1350	2560	1.0	0	3	1350	0	1976	0	2616 174th Ave NE	Redmond	WA 98052	USA
7	2014-05-02 00:00:00	482000.0	4.0	2.50	2710	35868	2.0	0	3	2710	0	1989	0	23762 SE 253rd Pl	Maple Valley	WA 98038	USA
8	2014-05-02 00:00:00	452500.0	3.0	2.50	2430	88426	1.0	0	4	1570	860	1985	0	46611-46625 SE 129th St	North Bend	WA 98045	USA
9	2014-05-02 00:00:00	640000.0	4.0	2.00	1520	6200	1.5	0	3	1520	0	1945	2010	6811 55th Ave NE	Seattle	WA 98115	USA

	date	price	bedrooms	bathrooms	sqft_living	sqft_lot	floors	condition	sqft_above	sqft_basement	yr_built	yr_renovated	street	city	statezip	country
4590	2014-07-08 00:00:00	380680.555556	4.0	2.50	2620	8331	2.0	3	2620	0	1991	0	13602 SE 186th Pl	Renton	WA 98058	USA
4591	2014-07-08 00:00:00	396166.666667	3.0	1.75	1880	5752	1.0	4	940	940	1945	0	3529 SW Webster St	Seattle	WA 98126	USA
4592	2014-07-08 00:00:00	252980.000000	4.0	2.50	2530	8169	2.0	3	2530	0	1993	0	37654 18th Pl S	Federal Way	WA 98003	USA
4593	2014-07-08 00:00:00	289373.307692	3.0	2.50	2538	4600	2.0	3	2538	0	2013	1923	5703 Charlotte Ave SE	Auburn	WA 98092	USA
4594	2014-07-09 00:00:00	210614.285714	3.0	2.50	1610	7223	2.0	3	1610	0	1994	0	26306 127th Ave SE	Kent	WA 98030	USA
4595	2014-07-09 00:00:00	308166.666667	3.0	1.75	1510	6360	1.0	4	1510	0	1954	1979	501 N 143rd St	Seattle	WA 98133	USA
4596	2014-07-09 00:00:00	534333.333333	3.0	2.50	1460	7573	2.0	3	1460	0	1983	2009	14855 SE 10th Pl	Bellevue	WA 98007	USA
4597	2014-07-09 00:00:00	416904.166667	3.0	2.50	3010	7014	2.0	3	3010	0	2009	0	759 Ilwaco Pl NE	Renton	WA 98059	USA
4598	2014-07-10 00:00:00	203400.000000	4.0	2.00	2090	6630	1.0	3	1070	1020	1974	0	5148 S Creston St	Seattle	WA 98178	USA
4599	2014-07-10 00:00:00	220600.000000	3.0	2.50	1490	8102	2.0	4	1490	0	1990	0	18717 SE 258th St	Covington	WA 98042	USA

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)